In Part I of this series, we explored overlap queries and the problems that accompany them, along with ways to improve their performance. We concluded by defining an overlap query in terms of timestamp ranges, which allowed us to use a new index type – known as GiST – that drastically sped up these types...…
The post Overlapping Ranges in Subsets in PostgreSQL appeared first on Simple Talk.
Learn about the challenges and solutions for applications when moving towards a microservices architecture for development and deployment.
How to automatically generate SQL Server RESTORE database commands for a set of databases based on the backup file contents.
This article covers change management processes for DBAs for installing and tracking database changes in a production environment.
Throughout this series, I’ve covered a number of topics about working with MongoDB collections and their data. One topic I have not covered is how to work with indexes. Similar to a relational database system, MongoDB lets you create indexes on your collections to help improve query read performance. You can create an index on...…
The post Working with MongoDB Indexes appeared first on Simple Talk.
This article uncovers some of the benefits of modernizing a traditional SQL Server architecture with Fabric and its current limitations.
Learn about data visualization using Python matplotlib to create a line chart, bar chart, histogram, pie chart, scatter plot, and box plot.
This tip's objective is to present and describe several T-SQL examples for creating, using, and analyzing GUIDs and assessing their uniqueness.
The amount of news brought by Ignite is huge. I was not expecting to find so many new features, resources, and discoveries. There may be dozens of summaries of the conference, and each one focusing on different highlights and news. On this article I will summarize what seems to be the most groundbreaking changes but...…
The post Breaking Down Ignite: A Pragmatic Look at the Conference’s Best Innovations appeared first on Simple Talk.
In this article, I explain how to convert a list of Excel files to CSV and move them to a separate folder with a Data Factory pipeline in Fabric's Data Lake.
When analytic data is stored directly in SQL Server, a clustered columnstore index is an ideal place for that data to reside. It is column-based, highly compressed, and supports a wide variety of optimizations for both reads and writes. When analytic data is stored in files, such as for use in Azure Data Factory, Synapse,...…
The post Reading and Writing Parquet Files in SQL Server appeared first on Simple Talk.
Learn how to create a microservice application with Azure container apps and Dapr using Bicep to develop infrastructure code and deploy templates.
This article explains how to aggregate data for Power BI reports and provides examples of running totals, running averages, min, max, and more.
When you think of how to store data in a database, you think of data types. A data type represents a method of how some bit of data is stored internally. Whether it’s numbers, text, dates, or even more complex structures like JSON or geometric shapes, there is an internal format and a method to...…
The post MySQL vs PostgreSQL: Numeric Datatype Comparison appeared first on Simple Talk.
Learn how to use production-like data for testing and development, but mask sensitive data quickly and efficiently with DataVeil.
This article looks at how to use SQL IS NULL and SQL IS NOT NULL operations in SQL Server along with use cases and working with NULL values.
How we handle data warehousing updates to dimension tables is crucial and this article covers Slowly Changing Dimensions (SCD Type 2) versus overwriting tables.
Learn how to create a moving average in SQL Server using older and less performant T-SQL and a modern way using windowing functions.
This tip explores leveraging existing SQL Server stored procedures within the Microsoft GraphQL API.
Like ancient Gaul, SQL is divided into three sub- languages. The DDL (Data Declaration Language) declares the data. This is where we find the data types, constraints, references and other structures that have to do with how the data stored . The DML (Data Manipulation Language) uses those declarations to change their contents or to...…
The post Data Control Language (aka Security) appeared first on Simple Talk.
In this article, we look at how to use Apache Kafka and Zookeeper to process and load streaming data.
In this article, we combine multiple columns from an SQL Server table into one column using three different methods to see the most efficient approach.
In this article, we look at using SQL Server metadata to better manage SQL code for things like stored procedures, user-defined functions, views, and more.
In this article, learn how to build a Power BI report from start to finish with a real-life example using COVID-related data.
In this article, we look at how to build an Azure streaming data collection and analysis process to analyze and predict stock prices.
This tip covers executing a Microsoft Fabric query using GraphQL API from an external application, introducing opportunities for data sharing, and exposing data through custom code.
This article examines SQL Server Reporting Services security and what you should know from the Configuration, Web Service, Folder, and Report Level.
Learn some tips and tricks when working with AI/virtual recruiters during the recruitment process and things you should know.
Check out this structured reference guide to just about anything you want to know about Power BI and Power BI report development.
This tip introduces some basic text preprocessing and cleaning techniques with Python that can be used before feeding the data to a machine-learning model. This article will explain Change Management, how DBAs are involved and can benefit from implementing standard processes for all database changes.
Check out this SQL Server stored procedure and function to auto-generate SQL variable coding syntax for many different programming languages.
Learn why Becton Dickinson has selected DBDefence to protect their SQL Server data across numerous medical devices in a cost effective manner.